use epam_evo;
db.geolocations.drop();
db.evodata.drop();
db.geolocations.insert({
	"city": "Astana",
	"country":"Kazakhstan",
	"pos":{
         "ob":50,
         "pb":70
      }
});
db.geolocations.insert({
	"city": "Karaganda",
	"country":"Kazakhstan",
	"pos":{
         "ob":53.1666667,
         "pb":73.43333329999996
      }
});
db.geolocations.insert({
	"city": "Moscow",
	"country":"Russia",
	"pos":{
         "ob":51.1666667,
         "pb":71.43333329999996
      }
});
db.geolocations.insert({
	"city": "Kyiv",
	"country":"Ukraine",
	"pos":{
         "ob":49.1666667,
         "pb":69.43333329999996
      }
});
db.geolocations.insert({
	"city": "NY",
	"country":"USA",
	"pos":{
         "ob":15.1666667,
         "pb":17.43333329999996
      }
});
db.geolocations.insert({
	"city": "Kharkiv",
	"country":"Ukraine",
	"pos":{
         "ob":7.1666667,
         "pb":7.43333329999996
      }
});

db.evodata.insert({
	"_id": 1,
	"quarter": 1,
	"year" : 1990,
	"cities":
	[
		{"city":"Astana", "employees": 10},
		{"city":"Karaganda", "employees": 5}	
	]
});

db.evodata.insert({
	"_id": 2,
	"quarter": 2,
	"year" : 1990,
	"cities":
	[
		{"city":"Astana", "employees": 80},
		{"city":"Karaganda", "employees": 50},
		{"city":"Moscow", "employees": 40},
		{"city":"Kyiv", "employees": 30},
		{"city":"NY", "employees": 1}	
	]
});

db.evodata.insert({
	"_id": 3,
	"quarter": 3,
	"year" : 1990,
	"cities":
	[
		{"city":"Astana", "employees": 80},
		{"city":"Karaganda", "employees": 50},
		{"city":"Moscow", "employees": 40},
		{"city":"Kyiv", "employees": 30},
		{"city":"NY", "employees": 1}	
	]
});

db.evodata.insert({
	"_id": 4,
	"quarter": 4,
	"year" : 1990,
	"cities":
	[
		{"city":"Astana", "employees": 80},
		{"city":"Karaganda", "employees": 50},
		{"city":"Moscow", "employees": 40},
		{"city":"Kyiv", "employees": 30},
		{"city":"NY", "employees": 1}	
	]
});

db.evodata.insert({
	"_id": 5,
	"quarter": 1,
	"year" : 1991,
	"cities":
	[
		{"city":"Astana", "employees": 80},
		{"city":"Karaganda", "employees": 50},
		{"city":"Moscow", "employees": 40},
		{"city":"Kyiv", "employees": 30},
		{"city":"NY", "employees": 1},
		{"city":"Kharkiv", "employees": 10}	
	]
});